Python Job: Staff Database Administrator

Zendesk is seeking a Staff MySQL DBA to help with our growing database environment. This role is key to helping maintain the high reliability and performance of our applications. We have many sharded databases and an environment which is constantly growing. We are looking for a hardworking and expert DBA with a drive for consistency and reliability and experienced knowledge in database administration and scripting.

• Work closely with the Engineering teams based in all the regions Zendesk has a presence

• Perform regular database schema changes with no downtime

• Perform and manage migrations of customer data between shards

• Build new database clusters/shards to support customer data growth

• Tackle performance issues and suggest optimizations

• Automate recurring DBA tasks

• Be part of DBA team on-call (when on rotation)

• Monitor database environment to maintain high availability and proactively identify and solve issues

• Work with and educate our Engineering teams to make good schema design choices and write efficient queries

• Supervise and improve our backup solution to ensure that our customers’ data is always secure

• Influence peer efficiency by staying on top of the industry, as well as contribute to the industry on behalf of Zendesk

• 8+ years of proven track record with MySQL architecture, replication, sharding, monitoring, troubleshooting and backups.

• Experience with automation and use of a scripting language (such as Bash, Perl, Python, Ruby, Go)

• Experience with SQL and stored routines

• Ability to be part of the DBA team on-call (when on rotation)

Preferred Qualifications:

• Working knowledge with AWS database technologies like Aurora, DynamoDB

• Experience working with MySQL in sharded environment and associated challenges with performance and growth

• Experience working with Terraform and CloudFormation technologies

• Previous experience with DataDog and ProxySQL will be a plus

• Multi-functionally in many areas without being constrained by your job function

• Good communication skills

• Collaborative, upbeat work ethic where you are encouraged to take ownership and have fun

At Zendesk, we believe that every great customer relationship stems from a conversation. So we built a customer service software company that designs solutions to foster better customer relationships. From large enterprises to startups, powerful, innovative customer experiences should be within reach for every company, no matter the size, industry or ambition. Zendesk serves more than 160,000 customers across a multitude of industries in over 30 languages. Zendesk is headquartered in San Francisco, and operates offices worldwide. Learn more at www.zendesk.com.

We believe in service. Learn more about how we provide support to our local communities with volunteering, grants and product donations.

Zendesk is an equal opportunity employer, and we’re proud of our ongoing efforts to foster global diversity, equity, & inclusion in the workplace. Individuals seeking employment and employees at Zendesk are considered without regard to race, color, religion, national origin, age, sex, gender, gender identity, gender expression, sexual orientation, marital status, medical condition, ancestry, disability, military or veteran status, or any other characteristic protected by applicable law. We are an AA/EEO/Veterans/Disabled employer. If you are based in the United States and would like more information about your EEO rights under the law, please click here.

Zendesk endeavors to make reasonable accommodations for applicants with disabilities and disabled veterans pursuant to applicable federal and state law. If you are an individual with a disability and require a reasonable accommodation to submit this application, complete any pre-employment testing, or otherwise participate in the employee selection process, please send an e-mail to [email protected] with your specific accommodation request.

By submitting your application, you agree that Zendesk may collect your personal data for recruiting, global organization planning, and related purposes. Zendesk's Candidate Privacy Notice explains what personal information Zendesk may process, where Zendesk may process your personal information, its purposes for processing your personal information, and the rights you can exercise over Zendesk’s use of your personal information.

About Zendesk - Champions of Customer Service
Zendesk started the customer experience revolution in 2007 by enabling any business around the world to take their customer service online. Today, Zendesk is the champion of great service everywhere for everyone, and powers billions of conversations, connecting more than 100,000 logos with hundreds of millions of customers over telephony, chat, email, messaging, social channels, communities, review sites and help centers. Zendesk products are built with love to be loved. The company was conceived in Copenhagen, Denmark, built and grown in California, taken public in New York City, and today employs more than 4,000 people across the world. Learn more at www.zendesk.com.

We believe in service. Learn more about how we provide support to our local communities with volunteering, grants and product donations.

Zendesk is an equal opportunity employer, and we’re proud of our ongoing efforts to foster global diversity, equity, & inclusion in the workplace. Individuals seeking employment and employees at Zendesk are considered without regard to race, color, religion, national origin, age, sex, gender, gender identity, gender expression, sexual orientation, marital status, medical condition, ancestry, disability, military or veteran status, or any other characteristic protected by applicable law. We are an AA/EEO/Veterans/Disabled employer. If you are based in the United States and would like more information about your EEO rights under the law, please click here.

For jobs in the US only: If hired, you will be required to provide proof of full vaccination against COVID-19 and will be provided with an opportunity to request an accommodation for reasons recognized by applicable law. This is a requirement of employment for jobs based in the United States.

For jobs in Australia, Brazil, Canada, the Philippines and Singapore: If hired and required to work in office or in person with others as part of your job, you will be required to provide proof of full vaccination against COVID-19. Zendesk will consider exceptions for reasons recognized by applicable law. This is a requirement of employment for jobs based in Australia, Brazil, Canada, the Philippines and Singapore.

Zendesk endeavors to make reasonable accommodations for applicants with disabilities and disabled veterans pursuant to applicable federal and state law. If you are an individual with a disability and require a reasonable accommodation to submit this application, complete any pre-employment testing, or otherwise participate in the employee selection process, please send an e-mail to [email protected] with your specific accommodation request.

By submitting your application, you agree that Zendesk may collect your personal data for recruiting, global organization planning, and related purposes. Zendesk's Candidate Privacy Notice explains what personal information Zendesk may process, where Zendesk may process your personal information, its purposes for processing your personal information, and the rights you can exercise over Zendesk’s use of your personal information.